From 1b9821bc20054c5081190710f37cf1d1bfb5e696 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Mon, 30 Oct 2006 01:04:00 +0000 Subject: [PATCH] Make sure users cannot be deleted unless they have done no editing. --- maintenance/postgres/tables.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 3224eaf212..6c22bb6f04 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -87,7 +87,7 @@ CREATE TABLE revision ( rev_page INTEGER NULL REFERENCES page (page_id) ON DELETE CASCADE, rev_text_id INTEGER NULL, -- FK rev_comment TEXT, - rev_user INTEGER NOT NULL REFERENCES mwuser(user_id), + rev_user INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE RESTRICT, rev_user_text TEXT NOT NULL, rev_timestamp TIMESTAMPTZ NOT NULL, rev_minor_edit CHAR NOT NULL DEFAULT '0', -- 2.20.1